{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["draft","final"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"draft","index":0,"n_rows":109,"n_cols":52,"rows_kept":109,"cut":false,"hidden":true,"merged":[[103,0,103,7],[105,0,105,7],[106,0,106,7],[107,0,107,7],[108,0,108,7],[97,0,97,7],[99,0,99,7],[100,0,100,7],[101,0,101,7],[102,0,102,7],[92,0,92,7],[93,0,93,7],[94,0,94,7],[95,0,95,7],[96,0,96,7],[86,0,86,7],[87,0,87,7],[89,0,89,7],[90,0,90,7],[91,0,91,7],[81,0,81,7],[82,0,82,7],[83,0,83,7],[84,0,84,7],[85,0,85,7],[75,0,75,7],[77,0,77,7],[78,0,78,7],[79,0,79,7],[80,0,80,7],[70,0,70,7],[71,0,71,7],[72,0,72,7],[73,0,73,7],[74,0,74,7],[63,0,63,7],[64,0,64,7],[66,0,66,7],[67,0,67,7],[68,0,68,7],[48,0,48,7],[50,0,50,7],[60,0,60,7],[61,0,61,7],[62,0,62,7],[43,0,43,7],[44,0,44,7],[45,0,45,7],[46,0,46,7],[47,0,47,7],[38,0,38,7],[39,0,39,7],[40,0,40,7],[41,0,41,7],[42,0,42,7],[33,0,33,7],[34,0,34,7],[35,0,35,7],[36,0,36,7],[37,0,37,7],[27,0,27,7],[28,0,28,7],[29,0,29,7],[30,0,30,7],[32,0,32,7],[22,0,22,7],[23,0,23,7],[24,0,24,7],[25,0,25,7],[26,0,26,7],[17,0,17,7],[18,0,18,7],[19,0,19,7],[20,0,20,7],[21,0,21,7],[12,0,12,7],[13,0,13,7],[14,0,14,7],[15,0,15,7],[16,0,16,7],[7,0,7,7],[8,0,8,7],[9,0,9,7],[10,0,10,7],[11,0,11,7],[1,5,1,7],[3,0,3,7],[4,0,4,7],[5,0,5,7],[6,0,6,7]]}
[{"$f":"CONCATENATE(AP2,AQ2,AR2,AS2,K3,AU2,K4)","v":"Western Cape: Draft Schedule of Service Delivery Standards Table - Stellenbosch (WC024) 2015/16"},null,null,null,null,null,null,null,null,"Key to note","select from drop down",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["Description","Ref","Year C-2","Year C-1","Year C-0","Current year ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014/15","Western Cape",": ","Draft Schedule of Service Delivery Standards Table"," - ",{"$f":"CONCATENATE(AW2,AX2,AY2,AZ2)","v":"Beaufort West (WC053)"}," ",{"$f":"$K$4","v":"2015/16"},"Beaufort West ","(","WC053",")"]
["Standard",null,"Actual Outcome","Actual Outcome","Audited Outcome","Original Budget","Adjusted Budget","Full Year Forecast","Service Level","Municipality (Code)","Stellenbosch (WC024)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015/16","Western Cape",": ","Draft Schedule of Service Delivery Standards Table"," - ",{"$f":"CONCATENATE(AW3,AX3,AY3,AZ3)","v":"Bergrivier (WC013)"}," ","2015/16","Bergrivier ","(","WC013",")"]
["Solid Waste Removal ",null,null,null,null,null,null,null,null,"Financial Year","2015/16",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016/17","Western Cape",": ","Draft Schedule of Service Delivery Standards Table"," - ","Bitou (WC047)"," ","2015/16","Bitou ","(","WC047",")"]
["Premise based removal (Residential Frequency)",null,null,null,null,null,null,null,"1 x per week",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017/18","Western Cape",": ","Draft Schedule of Service Delivery Standards Table"," - ","Breede Valley (WC025)"," ","2015/16","Breede Valley ","(","WC025",")"]
["Premise based removal (Business Frequency)",null,null,null,null,null,null,null,"3 x per week",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018/19","Western Cape",": ","Draft Schedule of Service Delivery Standards Table"," - ","Cape Agulhas (WC033)"," ","2015/16","Cape Agulhas ","(","WC033",")"]
["Bulk Removal (Frequency)",null,null,null,null,null,null,null,"Skip removal - daily",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019/20","Western Cape",": ","Draft Schedule of Service Delivery Standards Table"," - ","Cape Winelands District(DC2)"," ","2015/16","Cape Winelands District","(","DC2",")"]
["Removal Bags provided(Yes/No)",null,null,null,null,null,null,null,"Yes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020/21","Western Cape",": ","Draft Schedule of Service Delivery Standards Table"," - ","Cederberg (WC012)"," ","2015/16","Cederberg ","(","WC012",")"]
["Garden refuse removal Included (Yes/No)",null,null,null,null,null,null,null,"No",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021/22","Western Cape",": ","Draft Schedule of Service Delivery Standards Table"," - ","Central Karoo District (DC5)"," ","2015/16","Central Karoo District ","(","DC5",")"]
["Street Cleaning Frequency in CBD",null,null,null,null,null,null,null,"Daily",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022/23","Western Cape",": ","Draft Schedule of Service Delivery Standards Table"," - ","City of Cape Town(WC000)"," ","2015/16","City of Cape Town","(","WC000",")"]
["Street Cleaning Frequency in areas excluding CBD",null,null,null,null,null,null,null,"Daily",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023/24","Western Cape",": ","Draft Schedule of Service Delivery Standards Table"," - ","Drakenstein (WC023)"," ","2015/16","Drakenstein ","(","WC023",")"]
["How soon are public areas cleaned after events (24hours/48hours/longer)",null,null,null,null,null,null,null,"within 48 hours",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024/25","Western Cape",": ","Draft Schedule of Service Delivery Standards Table"," - ","Eden District (DC4)"," ","2015/16","Eden District ","(","DC4",")"]
["Clearing of illegal dumping (24hours/48hours/longer)",null,null,null,null,null,null,null,"24 hours",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Western Cape",": ","Draft Schedule of Service Delivery Standards Table"," - ","George (WC044)"," ","2015/16","George ","(","WC044",")"]
["Recycling or environmentally friendly practices(Yes/No)",null,null,null,null,null,null,null,"Yes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Western Cape",": ","Draft Schedule of Service Delivery Standards Table"," - ","Hessequa(WC042)"," ","2015/16","Hessequa","(","WC042",")"]
["Licenced landfill site(Yes/No)",null,null,null,null,null,null,null,"Yes Permitted landfill site",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Western Cape",": ","Draft Schedule of Service Delivery Standards Table"," - ","Kannaland (WC041)"," ","2015/16","Kannaland ","(","WC041",")"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Western Cape",": ","Draft Schedule of Service Delivery Standards Table"," - ","Knysna(WC048)"," ","2015/16","Knysna","(","WC048",")"]
["Water Service ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Western Cape",": ","Draft Schedule of Service Delivery Standards Table"," - ","Laingsburg (WC051)"," ","2015/16","Laingsburg ","(","WC051",")"]
["Water Quality rating (Blue/Green/Brown/N0 drop)",null,null,null,null,null,null,null,"No Bluedrop Evaluation since 2014",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Western Cape",": ","Draft Schedule of Service Delivery Standards Table"," - ","Langeberg(WC026)"," ","2015/16","Langeberg","(","WC026",")"]
["Is free water available to all? (All/only to the indigent consumers)",null,null,null,null,null,null,null,"No, only indigents",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Western Cape",": ","Draft Schedule of Service Delivery Standards Table"," - ","Matzikama (WC011)"," ","2015/16","Matzikama ","(","WC011",")"]
["Frequency of meter reading? (per month, per year)",null,null,null,null,null,null,null,"Once a month, 12 times a year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Western Cape",": ","Draft Schedule of Service Delivery Standards Table"," - ","Mossel Bay (WC043)"," ","2015/16","Mossel Bay ","(","WC043",")"]
["Are estimated consumption calculated on actual consumption over (two month's/three month's/longer period)",null,null,null,null,null,null,null,"Longer, previous year's consumption",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Western Cape",": ","Draft Schedule of Service Delivery Standards Table"," - ","Oudtshoorn (WC045)"," ","2015/16","Oudtshoorn ","(","WC045",")"]
["On average for how long does the municipality use estimates before reverting back to actual readings? (months)",null,null,null,null,null,null,null,"0, estimates only used when access to meters can not be obtained",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Western Cape",": ","Draft Schedule of Service Delivery Standards Table"," - ","Overberg District (DC3)"," ","2015/16","Overberg District ","(","DC3",")"]
["Duration (hours) before availability of water is restored in cases of service interruption (complete the sub questions)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Western Cape",": ","Draft Schedule of Service Delivery Standards Table"," - ","Overstrand (WC032)"," ","2015/16","Overstrand ","(","WC032",")"]
["One service connection affected (number of hours)",null,null,null,null,null,null,null,"2hours",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Western Cape",": ","Draft Schedule of Service Delivery Standards Table"," - ","Prince Albert (WC052)"," ","2015/16","Prince Albert ","(","WC052",")"]
["Up to 5 service connection affected (number of hours)",null,null,null,null,null,null,null,"5 hours",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Western Cape",": ","Draft Schedule of Service Delivery Standards Table"," - ","Saldanha Bay (WC014)"," ","2015/16","Saldanha Bay ","(","WC014",")"]
["Up to 20 service connection affected (number of hours)",null,null,null,null,null,null,null,"No feeder pipes > 800mm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Western Cape",": ","Draft Schedule of Service Delivery Standards Table"," - ",{"$f":"CONCATENATE(AW26,AX26,AY26,AZ26)","v":"Stellenbosch (WC024)"}," ","2015/16","Stellenbosch ","(","WC024",")"]
["Feeder pipe larger than 800mm (number of hours)",null,null,null,null,null,null,null,"Yes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Western Cape",": ","Draft Schedule of Service Delivery Standards Table"," - ","Swartland (WC015)"," ","2015/16","Swartland ","(","WC015",")"]
["What is the average minimum water flow in your municipality?",null,null,null,null,null,null,null,"38 Ml per day",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Western Cape",": ","Draft Schedule of Service Delivery Standards Table"," - ","Swellendam (WC034)"," ","2015/16","Swellendam ","(","WC034",")"]
["Do you practice any environmental or scarce resource protection activities as part of your operations? (Yes/No)",null,null,null,null,null,null,null,"Yes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Western Cape",": ","Draft Schedule of Service Delivery Standards Table"," - ","Theewaterskloof (WC031)"," ","2015/16","Theewaterskloof ","(","WC031",")"]
["How long does it take to replace faulty water meters? (days)",null,null,null,null,null,null,null,"3 weeks",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Western Cape",": ","Draft Schedule of Service Delivery Standards Table"," - ","West Coast District (DC1)"," ","2015/16","West Coast District ","(","DC1",")"]
["Do you have a cathodic protection system in place that is operational at this stage? (Yes/No)",null,null,null,null,null,null,null,"No",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Western Cape",": ","Draft Schedule of Service Delivery Standards Table"," - ","Witzenberg (WC022)"," ","2015/16","Witzenberg ","(","WC022",")"]
[]
["Electricity Service "]
["What is your electricity availability percentage on average per month? ",null,null,null,null,null,null,null,"99%"]
["Do your municipality have a ripple control in place that is operational? (Yes/No)",null,null,null,null,null,null,null,"Yes "]
["How much do you estimate is the cost saving in utilizing the ripple control system?",null,null,null,null,null,null,null,"R1m/annum"]
["What is the frequency of meters being read? (per month, per year)",null,null,null,null,null,null,null,"monthly"]
["Are estimated consumption calculated at consumption over (two month's/three month's/longer period)",null,null,null,null,null,null,null,"3 months"]
["On average for how long does the municipality use estimates before reverting back to actual readings? (months)",null,null,null,null,null,null,null,"No estimation"]
["Duration before availability of electricity is restored in cases of breakages (immediately/one day/two days/longer)",null,null,null,null,null,null,null,"95% sam eday"]
["Are accounts normally calculated on actual readings? (Yes/no)",null,null,null,null,null,null,null,"Yes "]
["Do you practice any environmental or scarce resource protection activities as part of your operations? (Yes/No)",null,null,null,null,null,null,null,"Yes "]
["How long does it take to replace faulty meters? (days)",null,null,null,null,null,null,null,"same day"]
["Do you have a plan to prevent illegal connections and prevention of electricity theft? (Yes/No)",null,null,null,null,null,null,null,"Yes "]
["How effective is the action plan in curbing line losses? (Good/Bad)",null,null,null,null,null,null,null,"Average"]
["How soon does the municipality provide a quotation to a customer upon a written request? (days)",null,null,null,null,null,null,null,"10 days"]
["How long does the municipality takes to provide electricity service where existing infrastructure can be used? (working days)",null,null,null,null,null,null,null,"30-45 days"]
["How long does the municipality takes to provide electricity service for low voltage users where network extension is not required? (working days)",null,null,null,null,null,null,null,"20-30 days"]
["How long does the municipality takes to provide electricity service for high voltage users where network extension is not required? (working days)",null,null,null,null,null,null,null,"20-30 days"]
[]
["Sewerage Service "]
["Are your purification system effective enough to put water back in to the system after purification?",null,null,null,null,null,null,null,"Some - In the process of upgrading"]
["To what extend do you subsidize your indigent consumers?",null,null,null,null,null,null,null,"100% (erf 0 -250m2)"]
["How long does it take to restore sewerage breakages on average"]
["Severe overflow? (hours)",null,null,null,null,null,null,null,"5 hours"]
["Sewer blocked pipes: Large pipes? (Hours)",null,null,null,null,null,null,null,"2 hours"]
["Sewer blocked pipes: Small pipes? (Hours)",null,null,null,null,null,null,null,"2 hours"]
["Spillage clean-up? (hours)",null,null,null,null,null,null,null,"2 hours"]
["Replacement of manhole covers? (Hours)",null,null,null,null,null,null,null,"2 hours"]
[]
["Road Infrastructure Services"]
["Time taken to repair a single pothole on a major road? (Hours)",null,null,null,null,null,null,null,"48 hrs"]
["Time taken to repair a single pothole on a minor road? (Hours)",null,null,null,null,null,null,null,"48 hrs"]
["Time taken to repair a road following an open trench service crossing? (Hours)",null,null,null,null,null,null,null,"72 hrs"]
["Time taken to repair walkways? (Hours)",null,null,null,null,null,null,null,"72 hrs"]
[]
["Property valuations"]
["How long does it take on average from completion to the first account being issued? (one month/three months or longer)",null,null,null,null,null,null,null,"1 Month"]
["Do you have any special rating properties? (Yes/No)",null,null,null,null,null,null,null,"Yes"]
[]
["Financial Management"]
["Is there any change in the situation of unauthorised and wasteful expenditure over time? (Decrease/Increase)",null,null,null,null,null,null,null,"Decrease"]
["Are the financial statement outsources? (Yes/No)",null,null,null,null,null,null,null,"No"]
["Are there Council adopted business process tsructuing the flow and managemet of documentation feeding to Trial Balalnce?"]
["How long does it take for an Tax/Invoice to be paid from the date it has been received?",null,null,null,null,null,null,null,"20 days"]
["Is there advance planning from SCM unit linking all departmental plans quaterly and annualy including for the next two to three years procurement plans?",null,null,null,null,null,null,null,"Yes, 1 year"]
[]
["Administration "]
["Reaction time on enquiries and requests?",null,null,null,null,null,null,null,"24 hours (Engineering Directorate)\n24 - 48 hrs (Communication section)\n10 - 20 days (Legal services)\n24 hrs (Political support)\n24 hrs (Records section)\n24 hrs (ICT section)"]
["Time to respond to a verbal customer enquiry or request? (working days)",null,null,null,null,null,null,null,"1 (Engineering Directorate)\n1 (Communication section)\n1 (Records section)\n1 (ICT section)"]
["Time to respond to a written customer enquiry or request? (working days)",null,null,null,null,null,null,null,"2 days (Engineering Directorate)\n1 - 2 days (Communication section)\n10 - 20 days (Legal services)\n1 day (Political support)\n1 day (Records section)\n1 day (ICT section)"]
["Time to resolve a customer enquiry or request? (working days)",null,null,null,null,null,null,null,"7 days (Engineering Directorate)\n7 day (Political support)\n1 day (Records section)\n1 day (ICT section)"]
["What percentage of calls are not answered? (5%,10% or more)",null,null,null,null,null,null,null,"Not yet measured"]
["How long does it take to respond to voice mails? (hours)",null,null,null,null,null,null,null,"8 hrs (Political support)\n24 hrs (Records section)\n24 hrs (ICT section)"]
["Does the municipality have control over locked enquiries? (Yes/No)",null,null,null,null,null,null,null,"Not yet measured"]
["Is there a reduction in the number of complaints or not? (Yes/No)",null,null,null,null,null,null,null,"Not yet measured"]
["How long does in take to open an account to a new customer? (1 day/ 2 days/ a week or longer)",null,null,null,null,null,null,null,"1 day"]
["How many times does SCM Unit, CFO's Unit and Technical unit sit to review and resolve SCM process delays other than normal monthly management meetings?",null,null,null,null,null,null,null,"As required"]
[]
["Community safety and licensing services"]
["How long does it take to register a vehicle? (minutes)",null,null,null,null,null,null,null,"30 minutes from the cashier transaction"]
["How long does it take to renew a vehicle license? (minutes)",null,null,null,null,null,null,null,"5-10 minutes from the cashier transaction"]
["How long does it take to issue a duplicate registration certificate vehicle? (minutes)",null,null,null,null,null,null,null,"15 minutes from the cashier transaction"]
["How long does it take to de-register a vehicle? (minutes)",null,null,null,null,null,null,null,"10 minutes from the cashier transaction"]
["How long does it take to renew a drivers license? (minutes)",null,null,null,null,null,null,null,"15 minutes from the cashier transaction"]
["What is the average reaction time of the fire service to an incident? (minutes)",null,null,null,null,null,null,null,"12 - 15 minutes after call was logged"]
["What is the average reaction time of the ambulance service to an incident in the urban area? (minutes)",null,null,null,null,null,null,null,"n/a"]
["What is the average reaction time of the ambulance service to an incident in the rural area? (minutes)",null,null,null,null,null,null,null,"n/a"]
[]
["Economic development"]
["How many economic development projects does the municipality drive?",null,null,null,null,null,null,null,"10 projects"]
["How many economic development programme are deemed to be catalytic in creating an enabling environment to unlock key economic growth projects?",null,null,null,null,null,null,null,"3 programmes"]
["What percentage of the projects have created sustainable job security?",null,null,null,null,null,null,null,0.4]
["Does the municipality have any incentive plans in place to create an conducive environment for economic development? (Yes/No)",null,null,null,null,null,null,null,"No"]
[]
["Other Service delivery and communication"]
["Is a information package handed to the new customer? (Yes/No)",null,null,null,null,null,null,null,"Yes, at all public libraries "]
["Does the municipality have training or information sessions to inform the community? (Yes/No)",null,null,null,null,null,null,null,"Yes, at all public libraries "]
["Are customers treated in a professional and humanly manner? (Yes/No)",null,null,null,null,null,null,null,"Yes"]

{"sheet":"final","index":1,"n_rows":109,"n_cols":52,"rows_kept":109,"cut":false,"hidden":false,"merged":[[13,0,13,7],[1,5,1,7],[3,0,3,7],[4,0,4,7],[5,0,5,7],[6,0,6,7],[7,0,7,7],[8,0,8,7],[9,0,9,7],[10,0,10,7],[11,0,11,7],[12,0,12,7],[25,0,25,7],[14,0,14,7],[15,0,15,7],[16,0,16,7],[17,0,17,7],[18,0,18,7],[19,0,19,7],[20,0,20,7],[21,0,21,7],[22,0,22,7],[23,0,23,7],[24,0,24,7],[26,0,26,7],[27,0,27,7],[28,0,28,7],[29,0,29,7],[30,0,30,7],[60,0,60,7],[40,0,40,7],[41,0,41,7],[42,0,42,7],[43,0,43,7],[44,0,44,7],[45,0,45,7],[46,0,46,7],[47,0,47,7],[48,0,48,7],[32,0,32,7],[50,0,50,7],[34,0,34,7],[35,0,35,7],[36,0,36,7],[37,0,37,7],[38,0,38,7],[39,0,39,7],[33,0,33,7],[68,0,68,7],[66,0,66,7],[70,0,70,7],[77,0,77,7],[89,0,89,7],[71,0,71,7],[72,0,72,7],[73,0,73,7],[74,0,74,7],[75,0,75,7],[61,0,61,7],[62,0,62,7],[63,0,63,7],[64,0,64,7],[67,0,67,7],[91,0,91,7],[78,0,78,7],[79,0,79,7],[80,0,80,7],[81,0,81,7],[82,0,82,7],[83,0,83,7],[84,0,84,7],[85,0,85,7],[86,0,86,7],[87,0,87,7],[90,0,90,7],[92,0,92,7],[93,0,93,7],[94,0,94,7],[95,0,95,7],[96,0,96,7],[108,0,108,7],[97,0,97,7],[100,0,100,7],[101,0,101,7],[102,0,102,7],[103,0,103,7],[106,0,106,7],[107,0,107,7],[99,0,99,7],[105,0,105,7]]}
[{"$f":"CONCATENATE(AP2,AQ2,AR2,AS2,K3,AU2,K4)","v":"Western Cape: Final Schedule of Service Delivery Standards Table - Central Karoo District (DC5) 2020/21"},null,null,null,null,null,null,null,null,"Key to note","select from drop down",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["Description","Ref","Year C-2","Year C-1","Year C-0","Current year ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014/15","Western Cape",": ","Final Schedule of Service Delivery Standards Table"," - ",{"$f":"CONCATENATE(AW2,AX2,AY2,AZ2)","v":"Beaufort West (WC053)"}," ",{"$f":"$K$4","v":"2020/21"},"Beaufort West ","(","WC053",")"]
["Standard",null,"Actual Outcome","Actual Outcome","Audited Outcome","Original Budget","Adjusted Budget","Full Year Forecast","Service Level","Municipality (Code)","Central Karoo District (DC5)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015/16","Western Cape",": ","Final Schedule of Service Delivery Standards Table"," - ",{"$f":"CONCATENATE(AW3,AX3,AY3,AZ3)","v":"Bergrivier (WC013)"}," ","2020/21","Bergrivier ","(","WC013",")"]
["Solid Waste Removal ",null,null,null,null,null,null,null,null,"Financial Year","2020/21",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016/17","Western Cape",": ","Final Schedule of Service Delivery Standards Table"," - ","Bitou (WC047)"," ","2020/21","Bitou ","(","WC047",")"]
["Premise based removal (Residential Frequency)",null,null,null,null,null,null,null,"N/A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017/18","Western Cape",": ","Final Schedule of Service Delivery Standards Table"," - ","Breede Valley (WC025)"," ","2020/21","Breede Valley ","(","WC025",")"]
["Premise based removal (Business Frequency)",null,null,null,null,null,null,null,"N/A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018/19","Western Cape",": ","Final Schedule of Service Delivery Standards Table"," - ","Cape Agulhas (WC033)"," ","2020/21","Cape Agulhas ","(","WC033",")"]
["Bulk Removal (Frequency)",null,null,null,null,null,null,null,"N/A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019/20","Western Cape",": ","Final Schedule of Service Delivery Standards Table"," - ","Cape Winelands District(DC2)"," ","2020/21","Cape Winelands District","(","DC2",")"]
["Removal Bags provided(Yes/No)",null,null,null,null,null,null,null,"N/A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020/21","Western Cape",": ","Final Schedule of Service Delivery Standards Table"," - ","Cederberg (WC012)"," ","2020/21","Cederberg ","(","WC012",")"]
["Garden refuse removal Included (Yes/No)",null,null,null,null,null,null,null,"N/A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021/22","Western Cape",": ","Final Schedule of Service Delivery Standards Table"," - ","Central Karoo District (DC5)"," ","2020/21","Central Karoo District ","(","DC5",")"]
["Street Cleaning Frequency in CBD",null,null,null,null,null,null,null,"N/A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022/23","Western Cape",": ","Final Schedule of Service Delivery Standards Table"," - ","City of Cape Town(WC000)"," ","2020/21","City of Cape Town","(","WC000",")"]
["Street Cleaning Frequency in areas excluding CBD",null,null,null,null,null,null,null,"N/A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023/24","Western Cape",": ","Final Schedule of Service Delivery Standards Table"," - ","Drakenstein (WC023)"," ","2020/21","Drakenstein ","(","WC023",")"]
["How soon are public areas cleaned after events (24hours/48hours/longer)",null,null,null,null,null,null,null,"N/A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024/25","Western Cape",": ","Final Schedule of Service Delivery Standards Table"," - ","Eden District (DC4)"," ","2020/21","Eden District ","(","DC4",")"]
["Clearing of illegal dumping (24hours/48hours/longer)",null,null,null,null,null,null,null,"N/A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Western Cape",": ","Final Schedule of Service Delivery Standards Table"," - ","George (WC044)"," ","2020/21","George ","(","WC044",")"]
["Recycling or environmentally friendly practices(Yes/No)",null,null,null,null,null,null,null,"N/A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Western Cape",": ","Final Schedule of Service Delivery Standards Table"," - ","Hessequa(WC042)"," ","2020/21","Hessequa","(","WC042",")"]
["Licenced landfill site(Yes/No)",null,null,null,null,null,null,null,"N/A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Western Cape",": ","Final Schedule of Service Delivery Standards Table"," - ","Kannaland (WC041)"," ","2020/21","Kannaland ","(","WC041",")"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Western Cape",": ","Final Schedule of Service Delivery Standards Table"," - ","Knysna(WC048)"," ","2020/21","Knysna","(","WC048",")"]
["Water Service ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Western Cape",": ","Final Schedule of Service Delivery Standards Table"," - ","Laingsburg (WC051)"," ","2020/21","Laingsburg ","(","WC051",")"]
["Water Quality rating (Blue/Green/Brown/N0 drop)",null,null,null,null,null,null,null,"N/A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Western Cape",": ","Final Schedule of Service Delivery Standards Table"," - ","Langeberg(WC026)"," ","2020/21","Langeberg","(","WC026",")"]
["Is free water available to all? (All/only to the indigent consumers)",null,null,null,null,null,null,null,"N/A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Western Cape",": ","Final Schedule of Service Delivery Standards Table"," - ","Matzikama (WC011)"," ","2020/21","Matzikama ","(","WC011",")"]
["Frequency of meter reading? (per month, per year)",null,null,null,null,null,null,null,"N/A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Western Cape",": ","Final Schedule of Service Delivery Standards Table"," - ","Mossel Bay (WC043)"," ","2020/21","Mossel Bay ","(","WC043",")"]
["Are estimated consumption calculated on actual consumption over (two month's/three month's/longer period)",null,null,null,null,null,null,null,"N/A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Western Cape",": ","Final Schedule of Service Delivery Standards Table"," - ","Oudtshoorn (WC045)"," ","2020/21","Oudtshoorn ","(","WC045",")"]
["On average for how long does the municipality use estimates before reverting back to actual readings? (months)",null,null,null,null,null,null,null,"N/A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Western Cape",": ","Final Schedule of Service Delivery Standards Table"," - ","Overberg District (DC3)"," ","2020/21","Overberg District ","(","DC3",")"]
["Duration (hours) before availability of water is restored in cases of service interruption (complete the sub questions)",null,null,null,null,null,null,null,"N/A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Western Cape",": ","Final Schedule of Service Delivery Standards Table"," - ","Overstrand (WC032)"," ","2020/21","Overstrand ","(","WC032",")"]
["One service connection affected (number of hours)",null,null,null,null,null,null,null,"N/A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Western Cape",": ","Final Schedule of Service Delivery Standards Table"," - ","Prince Albert (WC052)"," ","2020/21","Prince Albert ","(","WC052",")"]
["Up to 5 service connection affected (number of hours)",null,null,null,null,null,null,null,"N/A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Western Cape",": ","Final Schedule of Service Delivery Standards Table"," - ","Saldanha Bay (WC014)"," ","2020/21","Saldanha Bay ","(","WC014",")"]
["Up to 20 service connection affected (number of hours)",null,null,null,null,null,null,null,"N/A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Western Cape",": ","Final Schedule of Service Delivery Standards Table"," - ",{"$f":"CONCATENATE(AW26,AX26,AY26,AZ26)","v":"Stellenbosch (WC024)"}," ","2020/21","Stellenbosch ","(","WC024",")"]
["Feeder pipe larger than 800mm (number of hours)",null,null,null,null,null,null,null,"N/A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Western Cape",": ","Final Schedule of Service Delivery Standards Table"," - ","Swartland (WC015)"," ","2020/21","Swartland ","(","WC015",")"]
["What is the average minimum water flow in your municipality?",null,null,null,null,null,null,null,"N/A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Western Cape",": ","Final Schedule of Service Delivery Standards Table"," - ","Swellendam (WC034)"," ","2020/21","Swellendam ","(","WC034",")"]
["Do you practice any environmental or scarce resource protection activities as part of your operations? (Yes/No)",null,null,null,null,null,null,null,"N/A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Western Cape",": ","Final Schedule of Service Delivery Standards Table"," - ","Theewaterskloof (WC031)"," ","2020/21","Theewaterskloof ","(","WC031",")"]
["How long does it take to replace faulty water meters? (days)",null,null,null,null,null,null,null,"N/A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Western Cape",": ","Final Schedule of Service Delivery Standards Table"," - ","West Coast District (DC1)"," ","2020/21","West Coast District ","(","DC1",")"]
["Do you have a cathodic protection system in place that is operational at this stage? (Yes/No)",null,null,null,null,null,null,null,"N/A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Western Cape",": ","Final Schedule of Service Delivery Standards Table"," - ","Witzenberg (WC022)"," ","2020/21","Witzenberg ","(","WC022",")"]
[]
["Electricity Service "]
["What is your electricity availability percentage on average per month? ",null,null,null,null,null,null,null,"N/A"]
["Do your municipality have a ripple control in place that is operational? (Yes/No)",null,null,null,null,null,null,null,"N/A"]
["How much do you estimate is the cost saving in utilizing the ripple control system?",null,null,null,null,null,null,null,"N/A"]
["What is the frequency of meters being read? (per month, per year)",null,null,null,null,null,null,null,"N/A"]
["Are estimated consumption calculated at consumption over (two month's/three month's/longer period)",null,null,null,null,null,null,null,"N/A"]
["On average for how long does the municipality use estimates before reverting back to actual readings? (months)",null,null,null,null,null,null,null,"N/A"]
["Duration before availability of electricity is restored in cases of breakages (immediately/one day/two days/longer)",null,null,null,null,null,null,null,"N/A"]
["Are accounts normally calculated on actual readings? (Yes/no)",null,null,null,null,null,null,null,"N/A"]
["Do you practice any environmental or scarce resource protection activities as part of your operations? (Yes/No)",null,null,null,null,null,null,null,"N/A"]
["How long does it take to replace faulty meters? (days)",null,null,null,null,null,null,null,"N/A"]
["Do you have a plan to prevent illegal connections and prevention of electricity theft? (Yes/No)",null,null,null,null,null,null,null,"N/A"]
["How effective is the action plan in curbing line losses? (Good/Bad)",null,null,null,null,null,null,null,"N/A"]
["How soon does the municipality provide a quotation to a customer upon a written request? (days)",null,null,null,null,null,null,null,"N/A"]
["How long does the municipality takes to provide electricity service where existing infrastructure can be used? (working days)",null,null,null,null,null,null,null,"N/A"]
["How long does the municipality takes to provide electricity service for low voltage users where network extension is not required? (working days)",null,null,null,null,null,null,null,"N/A"]
["How long does the municipality takes to provide electricity service for high voltage users where network extension is not required? (working days)",null,null,null,null,null,null,null,"N/A"]
[]
["Sewerage Service "]
["Are your purification system effective enough to put water back in to the system after purification?",null,null,null,null,null,null,null,"N/A"]
["To what extend do you subsidize your indigent consumers?",null,null,null,null,null,null,null,"N/A"]
["How long does it take to restore sewerage breakages on average",null,null,null,null,null,null,null,"N/A"]
["Severe overflow? (hours)",null,null,null,null,null,null,null,"N/A"]
["Sewer blocked pipes: Large pipes? (Hours)",null,null,null,null,null,null,null,"N/A"]
["Sewer blocked pipes: Small pipes? (Hours)",null,null,null,null,null,null,null,"N/A"]
["Spillage clean-up? (hours)",null,null,null,null,null,null,null,"N/A"]
["Replacement of manhole covers? (Hours)",null,null,null,null,null,null,null,"N/A"]
[]
["Road Infrastructure Services"]
["Time taken to repair a single pothole on a major road? (Hours)",null,null,null,null,null,null,null,"N/A"]
["Time taken to repair a single pothole on a minor road? (Hours)",null,null,null,null,null,null,null,"N/A"]
["Time taken to repair a road following an open trench service crossing? (Hours)",null,null,null,null,null,null,null,"N/A"]
["Time taken to repair walkways? (Hours)",null,null,null,null,null,null,null,"N/A"]
[]
["Property valuations"]
["How long does it take on average from completion to the first account being issued? (one month/three months or longer)",null,null,null,null,null,null,null,"N/A"]
["Do you have any special rating properties? (Yes/No)",null,null,null,null,null,null,null,"N/A"]
[]
["Financial Management"]
["Is there any change in the situation of unauthorised and wasteful expenditure over time? (Decrease/Increase)",null,null,null,null,null,null,null,"Decrease"]
["Are the financial statement outsources? (Yes/No)",null,null,null,null,null,null,null,"Yes"]
["Are there Council adopted business process tsructuing the flow and managemet of documentation feeding to Trial Balalnce?",null,null,null,null,null,null,null,"No"]
["How long does it take for an Tax/Invoice to be paid from the date it has been received?",null,null,null,null,null,null,null,"30 days"]
["Is there advance planning from SCM unit linking all departmental plans quaterly and annualy including for the next two to three years procurement plans?",null,null,null,null,null,null,null,"No"]
[]
["Administration "]
["Reaction time on enquiries and requests?",null,null,null,null,null,null,null,"5 days"]
["Time to respond to a verbal customer enquiry or request? (working days)",null,null,null,null,null,null,null,"1 day"]
["Time to respond to a written customer enquiry or request? (working days)",null,null,null,null,null,null,null,"5 days"]
["Time to resolve a customer enquiry or request? (working days)",null,null,null,null,null,null,null,"10 days"]
["What percentage of calls are not answered? (5%,10% or more)",null,null,null,null,null,null,null,"20%"]
["How long does it take to respond to voice mails? (hours)",null,null,null,null,null,null,null,"1 day"]
["Does the municipality have control over locked enquiries? (Yes/No)",null,null,null,null,null,null,null,"N/A"]
["Is there a reduction in the number of complaints or not? (Yes/No)",null,null,null,null,null,null,null,"Yes"]
["How long does in take to open an account to a new customer? (1 day/ 2 days/ a week or longer)",null,null,null,null,null,null,null,"N/A"]
["How many times does SCM Unit, CFO's Unit and Technical unit sit to review and resolve SCM process delays other than normal monthly management meetings?",null,null,null,null,null,null,null,"Ad hoc"]
[]
["Community safety and licensing services"]
["How long does it take to register a vehicle? (minutes)",null,null,null,null,null,null,null,"N/A"]
["How long does it take to renew a vehicle license? (minutes)",null,null,null,null,null,null,null,"N/A"]
["How long does it take to issue a duplicate registration certificate vehicle? (minutes)",null,null,null,null,null,null,null,"N/A"]
["How long does it take to de-register a vehicle? (minutes)",null,null,null,null,null,null,null,"N/A"]
["How long does it take to renew a drivers license? (minutes)",null,null,null,null,null,null,null,"N/A"]
["What is the average reaction time of the fire service to an incident? (minutes)",null,null,null,null,null,null,null,"N/A"]
["What is the average reaction time of the ambulance service to an incident in the urban area? (minutes)",null,null,null,null,null,null,null,"N/A"]
["What is the average reaction time of the ambulance service to an incident in the rural area? (minutes)",null,null,null,null,null,null,null,"N/A"]
[]
["Economic development"]
["How many economic development projects does the municipality drive?",null,null,null,null,null,null,null,"See IDP"]
["How many economic development programme are deemed to be catalytic in creating an enabling environment to unlock key economic growth projects?",null,null,null,null,null,null,null,"See IDP"]
["What percentage of the projects have created sustainable job security?",null,null,null,null,null,null,null,"See IDP"]
["Does the municipality have any incentive plans in place to create an conducive environment for economic development? (Yes/No)",null,null,null,null,null,null,null,"See IDP"]
[]
["Other Service delivery and communication"]
["Is a information package handed to the new customer? (Yes/No)",null,null,null,null,null,null,null,"N/A"]
["Does the municipality have training or information sessions to inform the community? (Yes/No)",null,null,null,null,null,null,null,"Yes"]
["Are customers treated in a professional and humanly manner? (Yes/No)",null,null,null,null,null,null,null,"Yes"]